package cn.glutnn.mapper;

import cn.glutnn.entity.dto.RecommendDTO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import cn.glutnn.entity.Finance;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * (Finance)表数据库访问层
 *
 * @author msh
 * @since 2024-10-25 09:33:55
 */
public interface FinanceMapper extends BaseMapper<Finance> {

    List<RecommendDTO> selectAllRecommend(String name);

    List<RecommendDTO> selectWithNoneIntention(String name);

    @Select(" insert into tb_finance\n" +
            "\n" +
            "      (bank_id,own_name,real_name,status,money,rate,repayment,create_time,update_time)\n" +
            "\n" +
            "    values (#{bankId},#{ownName},#{realName},#{status},\n" +
            "      #{money},#{rate},\n" +
            "      #{repayment},\n" +
            "      #{createTime},\n" +
            "     #{updateTime})")
    Integer insertSelective(Finance finance);
}

